{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["numbers","audit1","audit2","audit3","audit4","comparisons","trends"],"not_rendered":{"charts":180,"images":0,"macros":0,"external_links":0,"defined_names":53,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"numbers","index":0,"n_rows":232,"n_cols":5,"rows_kept":232,"cut":false,"hidden":false,"merged":[[199,0,199,4],[8,0,8,4],[9,0,9,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[4,0,4,4]]}
[]
["Health Status of Patients with Diabetes"]
[]
["Use this spreadsheet to generate charts from the IHS Diabetes Audit. When you enter percentages in the columns below, the charts on the corresponding worksheets will automatically fill in. You can use the percentages on the Cumulative Audit report in the Diabetes Management System in RPMS, or use numbers from your annual IHS Diabetes Audit. This spreadsheet has columns for up to four reports. These might be time periods (years, quarters, etc.) or different groups (patients assigned to primary providers, IHS area-wide results, etc.). The final two sheets show all four columns together, with an emphasis either on different groupings or different time periods. You can move to different worksheets using the tabs at the bottom left corner of this screen."]
["Directions"]
["1.Items in the shaded cells are found in the Diabetes Audit.  Refer to either your annual Indian Health Service Diabetes Audit or generate the \"cumulative audit\" in the Diabetes Management System."]
["2. Enter corresponding PERCENTAGES (%) into the cells for each time frame."]
["3. Save a copy on your computer or network."]
["4. View and print your custom report by clicking on the tabs below.  "]
["5. Questions? Contact the Western Tribal Diabetes Program at 1-800-862-5497."]
[]
[null,"Audit 1","Audit 2","Audit 3","Audit 4"]
[null,"%","%","%","%"]
["HEADER INFORMATION"]
["Name (clinic, provider, etc.)"]
["Reporting period"]
["Number of patients in report"]
["Additional description (optional)"]
[]
["Gender of Patients with Diabetes"]
["Female"]
["Male"]
[]
["Age of Patients with Diabetes"]
["<15 years"]
["15-44 years"]
["45-64 years"]
["65 years and older"]
[]
["Type of Diabetes Diagnosed"]
["Type 1"]
["Type 2"]
["Unknown"]
[]
["Duration of Diabetes"]
["Less than 10 years"]
["10 years or more"]
["Diagnosis date not recorded"]
[]
["Weight Control in Patients with Diabetes "]
["Normal (BMI < 25.0)"]
["Overweight (BMI 25.0-25.9)"]
["Obese (BMI 30.0 or above)"]
["Height or Weight missing"]
[]
["Blood Sugar Control"]
["HbA1c <7"]
["HbA1c 7.0-7.9"]
["HbA1c 8.0-8.9"]
["HbA1c 9.0-9.9"]
["HbA1c 10.0-10.9"]
["HbA1c 11.0 or higher"]
["Undocumented"]
[]
["Blood Pressure Control"]
["Ideal BP Control (<120/<70)"]
["Target (120/70 - <130/<80)"]
["Adequate (130/80 - <140/<90)"]
["Inadequate (140/90 - <160/<95)"]
["Markedly Poor (160/95 or higher)"]
["BP control undetermined"]
[]
["Tobacco Use"]
["Current Tobacco User"]
["Counseled - Yes"]
["Counseled - No"]
["Counseled - Refused"]
["Not a current tobacco user"]
["Tobacco use not documented"]
[]
["Diabetes Therapy"]
["Diet and Exercise Alone"]
["Insulin "]
["Sulfonylurea"]
["Metformin"]
["Acarbose/Miglitol"]
["Glitazone"]
["Incretin mimetics (Byetta)"]
["DPP4 inhibitors (Januvia, Galvus)"]
["Amylin analogues (Symlin)"]
["Any Oral med combination"]
["Any Insulin + other med combination"]
["Unknown/refused"]
[]
["Antiplatelet Therapy"]
["Aspirin/Antiplatelet Prescription"]
["None"]
["Refused or Adverse Reaction"]
[]
["ACE Inhibitor (or ARB) Use"]
["Use in pts with overt proteinuria"]
["Use in pts with known hypertension"]
[]
["Lipid-Lowering Agent Use"]
["Use in pts with total chol ≥240"]
["Use in pts with LDL chol > 100"]
["Statin drug"]
["Non-statin drug"]
["Statin AND non-statin"]
["Refused or Adverse Reaction"]
[]
["Yearly Foot, Eye, and Dental Exams"]
["Foot Exam - Neuro & Vasc"]
["Eye Exam - Dilated"]
["Dental Exam"]
[]
["Immunizations"]
["Flu Vaccine - yearly"]
["Pneumovax - once"]
["Tetanus/Diphtheria (q 10 yrs)"]
[]
["LABORATORY EXAMS"]
[]
["Urine Protein Testing during Audit Period"]
["Yes"]
["No"]
["Refused"]
[]
["Type of urine protein testing"]
["Quantitative Alb:Creat Ratio"]
["Semi-quantitative Alb:Creat Ratio"]
["Protein:Creat Ratio"]
["Other quantitative test"]
["1+ protein or more on standard dipstick"]
["Other non-quantitative test"]
[]
["Results for patients tested with an A:C ratio or with 1+ protein or more on UA dipstick"]
["Normal urine albumin"]
["Microalbuminuria"]
["Overt proteinuria"]
[]
["Blood Creatinine Obtained in Past 12 Months"]
["Creatinine ≥2.0mg/dl"]
["Creatinine < 2.0 mg/dl"]
["Creatinine not tested/ Unknown"]
[]
["Estimated GFR Documented during Audit Period"]
[]
["Cholesterol Obtained in Past 12 Months"]
["Desirable (<200 mg/dl)"]
["Borderline (200-239 g/dl)"]
["High (240 mg/dl or more)"]
["Not tested"]
[]
["LDL Obtained in Past 12 Months"]
["LDL <100 mg/dl"]
["LDL 100-129 mg/dl"]
["LDL 130-160 mg/dl"]
["LDL >160"]
["Not tested"]
[]
["HDL Obtained in Past 12 Months"]
["HDL <35 mg/dl"]
["HDL 35-45 mg/dl"]
["HDL 46-55 mg/dl"]
["HDL >55"]
["Not tested"]
[]
["Triglycerides Obtained in Past 12 Months"]
["TG <150 mg/dl"]
["TG 150-199 mg/dl"]
["TG 200-400 mg/dl"]
["TG >400 mg/dl"]
["Not tested"]
[]
["EKG (age 30 and above)"]
["Performed in past 3 years"]
["Performed in past 5 years"]
["Ever performed"]
[]
["Tuberculosis Status"]
["PPD +, INH treatment complete"]
["PPD +, untreated, incomplete, or tx unknown"]
["PPD -, placed since DM dx"]
["PPD -, placed before DM dx"]
["PPD status unknown"]
["PPD -, date of diagnosis or PPD date unknown"]
["PPD refused"]
[]
["Diabetes-Related Education (Yearly)"]
["Diet Instruction by any provider"]
["Diet Instruction by RD"]
["Exercise Instruction"]
["Other Diabetes Education"]
["Any of the listed topics"]
[]
["Depression Identified as Active Diagnosis"]
["Yes"]
["No"]
[]
["Of the Patients without Active Depression Diagnosis, Proportion Screened for Depression in Past Year"]
["Screened"]
["Not Screened"]
["Refused Screening"]
[]
["All"]
[]
[]
[]
["These chart titles feed into the charts on the sheets for Audit 1 - Audit 4. Darker shaded cells are for charts with different denominators than the overall number of patients in the audit report."]
[]
["Change title text in this column:","Audit 1","Audit 2","Audit 3","Audit 4"]
[{"$f":"A20","v":"Gender of Patients with Diabetes"},{"$f":"$A203&\" \n(n=\"&B$17&\" Patients)\"","v":"Gender of Patients with Diabetes \n(n= Patients)"},{"$f":"$A203&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Gender of Patients with Diabetes \n(n= Patients)"},{"$f":"$A203&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Gender of Patients with Diabetes \n(n= Patients)"},{"$f":"$A203&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Gender of Patients with Diabetes \n(n= Patients)"}]
[{"$f":"A24","v":"Age of Patients with Diabetes"},{"$f":"$A204&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Age of Patients with Diabetes \n(n= Patients)"},{"$f":"$A204&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Age of Patients with Diabetes \n(n= Patients)"},{"$f":"$A204&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Age of Patients with Diabetes \n(n= Patients)"},{"$f":"$A204&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Age of Patients with Diabetes \n(n= Patients)"}]
[{"$f":"A30","v":"Type of Diabetes Diagnosed"},{"$f":"$A205&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Type of Diabetes Diagnosed \n(n= Patients)"},{"$f":"$A205&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Type of Diabetes Diagnosed \n(n= Patients)"},{"$f":"$A205&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Type of Diabetes Diagnosed \n(n= Patients)"},{"$f":"$A205&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Type of Diabetes Diagnosed \n(n= Patients)"}]
[{"$f":"A35","v":"Duration of Diabetes"},{"$f":"$A206&\" (n=\"&numbers!B$17&\" Patients)\"","v":"Duration of Diabetes (n= Patients)"},{"$f":"$A206&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Duration of Diabetes (n= Patients)"},{"$f":"$A206&\" (n=\"&numbers!D$17&\" Patients)\"","v":"Duration of Diabetes (n= Patients)"},{"$f":"$A206&\" (n=\"&numbers!E$17&\" Patients)\"","v":"Duration of Diabetes (n= Patients)"}]
[{"$f":"A40","v":"Weight Control in Patients with Diabetes "},{"$f":"$A207&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Weight Control in Patients with Diabetes  \n(n= Patients)"},{"$f":"$A207&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Weight Control in Patients with Diabetes  \n(n= Patients)"},{"$f":"$A207&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Weight Control in Patients with Diabetes  \n(n= Patients)"},{"$f":"$A207&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Weight Control in Patients with Diabetes  \n(n= Patients)"}]
[{"$f":"A46","v":"Blood Sugar Control"},{"$f":"$A208&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Blood Sugar Control \n(n= Patients)"},{"$f":"$A208&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Blood Sugar Control \n(n= Patients)"},{"$f":"$A208&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Blood Sugar Control \n(n= Patients)"},{"$f":"$A208&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Blood Sugar Control \n(n= Patients)"}]
[{"$f":"A55","v":"Blood Pressure Control"},{"$f":"$A209&\" (n=\"&numbers!B$17&\" Patients)\"","v":"Blood Pressure Control (n= Patients)"},{"$f":"$A209&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Blood Pressure Control (n= Patients)"},{"$f":"$A209&\" (n=\"&numbers!D$17&\" Patients)\"","v":"Blood Pressure Control (n= Patients)"},{"$f":"$A209&\" (n=\"&numbers!E$17&\" Patients)\"","v":"Blood Pressure Control (n= Patients)"}]
[{"$f":"A63","v":"Tobacco Use"},{"$f":"$A210&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Tobacco Use \n(n= Patients)"},{"$f":"$A210&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Tobacco Use (n= Patients)"},{"$f":"$A210&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Tobacco Use \n(n= Patients)"},{"$f":"$A210&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Tobacco Use \n(n= Patients)"}]
["Tobacco Cessation Counseling for Current Tobacco Users",{"$f":"$A211&\" \n(n=\"&(ROUND((B$17*B64/100),0))&\" Patients)\"","v":"Tobacco Cessation Counseling for Current Tobacco Users \n(n=0 Patients)"},{"$f":"$A211&\" \n(n=\"&(ROUND((C$17*C64/100),0))&\" Patients)\"","v":"Tobacco Cessation Counseling for Current Tobacco Users \n(n=0 Patients)"},{"$f":"$A211&\" \n(n=\"&(ROUND((D$17*D64/100),0))&\" Patients)\"","v":"Tobacco Cessation Counseling for Current Tobacco Users \n(n=0 Patients)"},{"$f":"$A211&\" \n(n=\"&(ROUND((E$17*E64/100),0))&\" Patients)\"","v":"Tobacco Cessation Counseling for Current Tobacco Users \n(n=0 Patients)"}]
[{"$f":"A71","v":"Diabetes Therapy"},{"$f":"$A212&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Diabetes Therapy \n(n= Patients)"},{"$f":"$A212&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Diabetes Therapy \n(n= Patients)"},{"$f":"$A212&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Diabetes Therapy \n(n= Patients)"},{"$f":"$A212&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Diabetes Therapy \n(n= Patients)"}]
[{"$f":"A85","v":"Antiplatelet Therapy"},{"$f":"$A213&\" (n=\"&numbers!B$17&\" Patients)\"","v":"Antiplatelet Therapy (n= Patients)"},{"$f":"$A213&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Antiplatelet Therapy (n= Patients)"},{"$f":"$A213&\" (n=\"&numbers!D$17&\" Patients)\"","v":"Antiplatelet Therapy (n= Patients)"},{"$f":"$A213&\" (n=\"&numbers!E$17&\" Patients)\"","v":"Antiplatelet Therapy (n= Patients)"}]
[{"$f":"A90","v":"ACE Inhibitor (or ARB) Use"},{"$f":"$A214&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"ACE Inhibitor (or ARB) Use \n(n= Patients)"},{"$f":"$A214&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"ACE Inhibitor (or ARB) Use \n(n= Patients)"},{"$f":"$A214&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"ACE Inhibitor (or ARB) Use \n(n= Patients)"},{"$f":"$A214&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"ACE Inhibitor (or ARB) Use \n(n= Patients)"}]
[{"$f":"A94","v":"Lipid-Lowering Agent Use"},{"$f":"$A215&\" (n=\"&numbers!B$17&\" Patients)\"","v":"Lipid-Lowering Agent Use (n= Patients)"},{"$f":"$A215&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Lipid-Lowering Agent Use (n= Patients)"},{"$f":"$A215&\" (n=\"&numbers!D$17&\" Patients)\"","v":"Lipid-Lowering Agent Use (n= Patients)"},{"$f":"$A215&\" (n=\"&numbers!E$17&\" Patients)\"","v":"Lipid-Lowering Agent Use (n= Patients)"}]
["Type of Lipid-Lowering Agent",{"$f":"$A216","v":"Type of Lipid-Lowering Agent"},{"$f":"$A216","v":"Type of Lipid-Lowering Agent"},{"$f":"$A216","v":"Type of Lipid-Lowering Agent"},{"$f":"$A216","v":"Type of Lipid-Lowering Agent"}]
[{"$f":"A102","v":"Yearly Foot, Eye, and Dental Exams"},{"$f":"$A217&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Yearly Foot, Eye, and Dental Exams \n(n= Patients)"},{"$f":"$A217&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Yearly Foot, Eye, and Dental Exams \n(n= Patients)"},{"$f":"$A217&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Yearly Foot, Eye, and Dental Exams \n(n= Patients)"},{"$f":"$A217&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Yearly Foot, Eye, and Dental Exams \n(n= Patients)"}]
[{"$f":"A107","v":"Immunizations"},{"$f":"$A218&\" (n=\"&numbers!B$17&\" Patients)\"","v":"Immunizations (n= Patients)"},{"$f":"$A218&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Immunizations \n(n= Patients)"},{"$f":"$A218&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Immunizations \n(n= Patients)"},{"$f":"$A218&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Immunizations \n(n= Patients)"}]
[{"$f":"A114","v":"Urine Protein Testing during Audit Period"},{"$f":"$A219&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Urine Protein Testing during Audit Period \n(n= Patients)"},{"$f":"$A219&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Urine Protein Testing during Audit Period \n(n= Patients)"},{"$f":"$A219&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Urine Protein Testing during Audit Period \n(n= Patients)"},{"$f":"$A219&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Urine Protein Testing during Audit Period \n(n= Patients)"}]
[{"$f":"A119","v":"Type of urine protein testing"},{"$f":"$A220&\" (n=\"&(ROUND((B$17*B115/100),0))&\" Patients)\"","v":"Type of urine protein testing (n=0 Patients)"},{"$f":"$A220&\" (n=\"&(ROUND((C$17*C115/100),0))&\" Patients)\"","v":"Type of urine protein testing (n=0 Patients)"},{"$f":"$A220&\" (n=\"&(ROUND((D$17*D115/100),0))&\" Patients)\"","v":"Type of urine protein testing (n=0 Patients)"},{"$f":"$A220&\" (n=\"&(ROUND((E$17*E115/100),0))&\" Patients)\"","v":"Type of urine protein testing (n=0 Patients)"}]
[{"$f":"A127","v":"Results for patients tested with an A:C ratio or with 1+ protein or more on UA dipstick"},{"$f":"$A$221","v":"Results for patients tested with an A:C ratio or with 1+ protein or more on UA dipstick"},{"$f":"A221","v":"Results for patients tested with an A:C ratio or with 1+ protein or more on UA dipstick"},{"$f":"A221","v":"Results for patients tested with an A:C ratio or with 1+ protein or more on UA dipstick"},{"$f":"A221","v":"Results for patients tested with an A:C ratio or with 1+ protein or more on UA dipstick"}]
[{"$f":"A132","v":"Blood Creatinine Obtained in Past 12 Months"},{"$f":"$A222&\" (n=\"&numbers!B$17&\" Patients)\"","v":"Blood Creatinine Obtained in Past 12 Months (n= Patients)"},{"$f":"$A222&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Blood Creatinine Obtained in Past 12 Months (n= Patients)"},{"$f":"$A222&\" (n=\"&numbers!D$17&\" Patients)\"","v":"Blood Creatinine Obtained in Past 12 Months (n= Patients)"},{"$f":"$A222&\" (n=\"&numbers!E$17&\" Patients)\"","v":"Blood Creatinine Obtained in Past 12 Months (n= Patients)"}]
[{"$f":"A137","v":"Estimated GFR Documented during Audit Period"},{"$f":"$A223&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Estimated GFR Documented during Audit Period \n(n= Patients)"},{"$f":"$A223&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Estimated GFR Documented during Audit Period \n(n= Patients)"},{"$f":"$A223&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Estimated GFR Documented during Audit Period \n(n= Patients)"},{"$f":"$A223&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Estimated GFR Documented during Audit Period \n(n= Patients)"}]
["Total Cholesterol in Past 12 Months",{"$f":"$A224&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Total Cholesterol in Past 12 Months \n(n= Patients)"},{"$f":"$A224&\" (n=\"&numbers!C$17&\" Patients)\"","v":"Total Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A224&\" (n=\"&numbers!D$17&\" Patients)\"","v":"Total Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A224&\" (n=\"&numbers!E$17&\" Patients)\"","v":"Total Cholesterol in Past 12 Months (n= Patients)"}]
["HDL Cholesterol in Past 12 Months",{"$f":"$A225&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"HDL Cholesterol in Past 12 Months \n(n= Patients)"},{"$f":"$A225&\" (n=\"&numbers!C$17&\" Patients)\"","v":"HDL Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A225&\" (n=\"&numbers!D$17&\" Patients)\"","v":"HDL Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A225&\" (n=\"&numbers!E$17&\" Patients)\"","v":"HDL Cholesterol in Past 12 Months (n= Patients)"}]
["LDL Cholesterol in Past 12 Months",{"$f":"$A226&\" (n=\"&numbers!B$17&\" Patients)\"","v":"LDL Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A226&\" (n=\"&numbers!C$17&\" Patients)\"","v":"LDL Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A226&\" (n=\"&numbers!D$17&\" Patients)\"","v":"LDL Cholesterol in Past 12 Months (n= Patients)"},{"$f":"$A226&\" (n=\"&numbers!E$17&\" Patients)\"","v":"LDL Cholesterol in Past 12 Months (n= Patients)"}]
["Triglycerides in Past 12 Months",{"$f":"$A227&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Triglycerides in Past 12 Months \n(n= Patients)"},{"$f":"$A227&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Triglycerides in Past 12 Months \n(n= Patients)"},{"$f":"$A227&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Triglycerides in Past 12 Months \n(n= Patients)"},{"$f":"$A227&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Triglycerides in Past 12 Months \n(n= Patients)"}]
[{"$f":"A166","v":"EKG (age 30 and above)"},{"$f":"$A228","v":"EKG (age 30 and above)"},{"$f":"A228","v":"EKG (age 30 and above)"},{"$f":"A228","v":"EKG (age 30 and above)"},{"$f":"A228","v":"EKG (age 30 and above)"}]
[{"$f":"A171","v":"Tuberculosis Status"},{"$f":"$A229&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Tuberculosis Status \n(n= Patients)"},{"$f":"$A229&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Tuberculosis Status \n(n= Patients)"},{"$f":"$A229&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Tuberculosis Status \n(n= Patients)"},{"$f":"$A229&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Tuberculosis Status \n(n= Patients)"}]
[{"$f":"A180","v":"Diabetes-Related Education (Yearly)"},{"$f":"$A230&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Diabetes-Related Education (Yearly) \n(n= Patients)"},{"$f":"$A230&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Diabetes-Related Education (Yearly) \n(n= Patients)"},{"$f":"$A230&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Diabetes-Related Education (Yearly) \n(n= Patients)"},{"$f":"$A230&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Diabetes-Related Education (Yearly) \n(n= Patients)"}]
[{"$f":"A187","v":"Depression Identified as Active Diagnosis"},{"$f":"$A231&\" \n(n=\"&numbers!B$17&\" Patients)\"","v":"Depression Identified as Active Diagnosis \n(n= Patients)"},{"$f":"$A231&\" \n(n=\"&numbers!C$17&\" Patients)\"","v":"Depression Identified as Active Diagnosis \n(n= Patients)"},{"$f":"$A231&\" \n(n=\"&numbers!D$17&\" Patients)\"","v":"Depression Identified as Active Diagnosis \n(n= Patients)"},{"$f":"$A231&\" \n(n=\"&numbers!E$17&\" Patients)\"","v":"Depression Identified as Active Diagnosis \n(n= Patients)"}]
[{"$f":"A191","v":"Of the Patients without Active Depression Diagnosis, Proportion Screened for Depression in Past Year"},{"$f":"$A232&\" (n=\"&(ROUND((B$17*B189/100),0))&\" Patients)\"","v":"Of the Patients without Active Depression Diagnosis, Proportion Screened for Depression in Past Year (n=0 Patients)"},{"$f":"$A232&\" (n=\"&(ROUND((C$17*C189/100),0))&\" Patients)\"","v":"Of the Patients without Active Depression Diagnosis, Proportion Screened for Depression in Past Year (n=0 Patients)"},{"$f":"$A232&\" (n=\"&(ROUND((D$17*D189/100),0))&\" Patients)\"","v":"Of the Patients without Active Depression Diagnosis, Proportion Screened for Depression in Past Year (n=0 Patients)"},{"$f":"$A232&\" (n=\"&(ROUND((E$17*E189/100),0))&\" Patients)\"","v":"Of the Patients without Active Depression Diagnosis, Proportion Screened for Depression in Past Year (n=0 Patients)"}]

{"sheet":"audit1","index":1,"n_rows":429,"n_cols":2,"rows_kept":429,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[6,0,6,1],[4,0,4,1]]}
[{"$f":"numbers!A2","v":"Health Status of Patients with Diabetes"}]
[{"$f":"numbers!B15","v":0}]
["This information is for the following time period:",{"$f":"numbers!B16","v":"00:00:00"}]
["Number of patients included in this report (denominator):",{"$f":"numbers!B17","v":0}]
[{"$f":"IF(ISBLANK(numbers!B18),\"\",numbers!B18)","v":""}]
[]
["  Diabetes is a disease that is disproportionately affecting the American Indian and Alaska Native communities. Armed with the right information we can work together to fight and eventually prevent this disease. First, we need to know the true facts about diabetes in each tribe and community. \n  This information is based on your clinic's tracking of diabetes in your community for a one year time frame. It is based on information tracked in the Resource Patient Management System (RPMS) or compiled in an annual chart review. By looking at this information we can best target health resources, support those in the community with diabetes and prevent diabetes in future generations.\n  Much of the narrative information found in this report is taken from the 2006 Indian Health Service Standards of Care for Adults with Type 2 Diabetes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"audit2","index":2,"n_rows":429,"n_cols":2,"rows_kept":429,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[4,0,4,1],[6,0,6,1]]}
[{"$f":"numbers!A2","v":"Health Status of Patients with Diabetes"}]
[{"$f":"numbers!C15","v":0}]
["This information is for the following time period:",{"$f":"numbers!C16","v":"00:00:00"}]
["Number of patients included in this report (denominator):",{"$f":"numbers!C17","v":0}]
[{"$f":"IF(ISBLANK(numbers!C18),\"\",numbers!C18)","v":""}]
[]
["  Diabetes is a disease that is disproportionately affecting the American Indian and Alaska Native communities. Armed with the right information we can work together to fight and eventually prevent this disease. First, we need to know the true facts about diabetes in each tribe and community. \n  This information is based on your clinic's tracking of diabetes in your community for a one year time frame. It is based on information tracked in the Resource Patient Management System (RPMS) or compiled in an annual chart review. By looking at this information we can best target health resources, support those in the community with diabetes and prevent diabetes in future generations.\n  Much of the narrative information found in this report is taken from the 2006 Indian Health Service Standards of Care for Adults with Type 2 Diabetes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"audit3","index":3,"n_rows":429,"n_cols":2,"rows_kept":429,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[4,0,4,1],[6,0,6,1]]}
[{"$f":"numbers!A2","v":"Health Status of Patients with Diabetes"}]
[{"$f":"numbers!D15","v":0}]
["This information is for the following time period:",{"$f":"numbers!D16","v":"00:00:00"}]
["Number of patients included in this report (denominator):",{"$f":"numbers!D17","v":0}]
[{"$f":"IF(ISBLANK(numbers!D18),\"\",numbers!D18)","v":""}]
[]
["  Diabetes is a disease that is disproportionately affecting the American Indian and Alaska Native communities. Armed with the right information we can work together to fight and eventually prevent this disease. First, we need to know the true facts about diabetes in each tribe and community. \n  This information is based on your clinic's tracking of diabetes in your community for a one year time frame. It is based on information tracked in the Resource Patient Management System (RPMS) or compiled in an annual chart review. By looking at this information we can best target health resources, support those in the community with diabetes and prevent diabetes in future generations.\n  Much of the narrative information found in this report is taken from the 2006 Indian Health Service Standards of Care for Adults with Type 2 Diabetes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"audit4","index":4,"n_rows":429,"n_cols":2,"rows_kept":429,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[4,0,4,1],[6,0,6,1]]}
[{"$f":"numbers!A2","v":"Health Status of Patients with Diabetes"}]
[{"$f":"numbers!E15","v":0}]
["This information is for the following time period:",{"$f":"numbers!E16","v":"00:00:00"}]
["Number of patients included in this report (denominator):",{"$f":"numbers!E17","v":0}]
[{"$f":"IF(ISBLANK(numbers!E18),\"\",numbers!E18)","v":""}]
[]
["  Diabetes is a disease that is disproportionately affecting the American Indian and Alaska Native communities. Armed with the right information we can work together to fight and eventually prevent this disease. First, we need to know the true facts about diabetes in each tribe and community. \n  This information is based on your clinic's tracking of diabetes in your community for a one year time frame. It is based on information tracked in the Resource Patient Management System (RPMS) or compiled in an annual chart review. By looking at this information we can best target health resources, support those in the community with diabetes and prevent diabetes in future generations.\n  Much of the narrative information found in this report is taken from the 2006 Indian Health Service Standards of Care for Adults with Type 2 Diabetes."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"comparisons","index":5,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,7],[0,0,0,7],[1,0,1,7],[6,0,6,7]]}
["Diabetes Data Report - Comparison"]
[{"$f":"numbers!B16","v":0}]
["This information is for the following groups:"]
["Name",{"$f":"numbers!B15","v":0},null,{"$f":"numbers!C15","v":0},null,{"$f":"numbers!D15","v":0},null,{"$f":"numbers!E15","v":0}]
["Denominator",{"$f":"numbers!B17","v":0},null,{"$f":"numbers!C17","v":0},null,{"$f":"numbers!D17","v":0},null,{"$f":"numbers!E17","v":0}]
[null,{"$f":"IF(ISBLANK(numbers!B18),\" \",numbers!B18)","v":" "},null,{"$f":"IF(ISBLANK(numbers!C18),\" \",numbers!C18)","v":" "},null,{"$f":"IF(ISBLANK(numbers!D18),\" \",numbers!D18)","v":" "},null,{"$f":"IF(ISBLANK(numbers!E18),\" \",numbers!E18)","v":" "}]
["The following report shows four different diabetes patient care audits. By viewing the diabetes-related information over time we can identify strengths in patient care and disease management. As you look at these graphs think about factors that may be contributing to the differences (example: starting new intervention programs, changes in standards of care, changes in staffing, etc.).This information can also assist your program in pinpointing areas needing additional attention."]

{"sheet":"trends","index":6,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,0,6,7],[2,0,2,7],[0,0,0,7],[1,0,1,7]]}
["Diabetes Data Report - Trends"]
[{"$f":"numbers!B15","v":0}]
["This information is for the following time periods:"]
["Name",{"$f":"numbers!B16","v":"00:00:00"},null,{"$f":"numbers!C16","v":"00:00:00"},null,{"$f":"numbers!D16","v":"00:00:00"},null,{"$f":"numbers!E16","v":"00:00:00"}]
["Denominator",{"$f":"numbers!B17","v":0},null,{"$f":"numbers!C17","v":0},null,{"$f":"numbers!D17","v":0},null,{"$f":"numbers!E17","v":0}]
[null,{"$f":"IF(ISBLANK(numbers!B18),\" \",numbers!B18)","v":" "},null,{"$f":"IF(ISBLANK(numbers!C18),\" \",numbers!C18)","v":" "},null,{"$f":"IF(ISBLANK(numbers!D18),\" \",numbers!D18)","v":" "},null,{"$f":"IF(ISBLANK(numbers!E18),\" \",numbers!E18)","v":" "}]
["The following report tracks diabetes over four time periods. By viewing the diabetes-related information over time we can track improvements in patient care and disease management. As you look at these graphs think about factors that may be contributing to the changes over time (example: starting new intervention programs, changes in standards of care, changes in staffing, etc.). This information can also assist your program in pinpointing areas needing additional attention."]